﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SystemDBDataSet" targetNamespace="http://tempuri.org/SystemDBDataSet.xsd" xmlns:mstns="http://tempuri.org/SystemDBDataSet.xsd" xmlns="http://tempuri.org/SystemDBDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SystemDB" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SystemDB (Settings)" PropertyReference="ApplicationSettings.UI.Properties.Settings.GlobalReference.Default.SystemDB" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CarTypeTableAdapter" GeneratorDataComponentClassName="CarTypeTableAdapter" Name="CarType" UserDataComponentName="CarTypeTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="CarType" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, Name FROM CarType</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="CarType" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetDataBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Name, ID
FROM CarType
WHERE (ID = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="ID" DataSourceName="CarType" DataTypeServer="DbType.Byte" DbType="Byte" Direction="Input" ParameterName="ID" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="VehicleInfoTableAdapter" GeneratorDataComponentClassName="VehicleInfoTableAdapter" Name="VehicleInfo" UserDataComponentName="VehicleInfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillShow" GenerateMethods="Fill" GenerateShortCommands="false" GeneratorSourceName="FillShow" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="FillShow">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT VehicleInfo.LicensePlate, VehicleInfo.VIN, CarType.Name, VehicleInfo.RIN, 
      VehicleInfo.Brand, VehicleInfo.Model, VehicleInfo.BuyDate, VehicleInfo.CheckMonth, 
      VehicleInfo.Factor, VehicleInfo.Sensor, VehicleInfo.OilPer, VehicleInfo.CarTypeID, 
      VehicleInfo.[Memo], VehicleInfo.Setup, VehicleInfo.Sign, VehicleInfo.LimitSpeed, 
      VehicleInfo.RecordTime, VehicleInfo.RestTime, VehicleInfo.TiredTime, 
      VehicleInfo.SuperTime, VehicleInfo.Operator, VehicleInfo.LastUpdateTime
FROM (VehicleInfo INNER JOIN
      CarType ON VehicleInfo.CarTypeID = CarType.ID)
ORDER BY VehicleInfo.LastUpdateTime DESC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="LicensePlate" DataSetColumn="LicensePlate" />
              <Mapping SourceColumn="VIN" DataSetColumn="VIN" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="RIN" DataSetColumn="RIN" />
              <Mapping SourceColumn="Brand" DataSetColumn="Brand" />
              <Mapping SourceColumn="Model" DataSetColumn="Model" />
              <Mapping SourceColumn="CheckMonth" DataSetColumn="CheckMonth" />
              <Mapping SourceColumn="OilPer" DataSetColumn="OilPer" />
              <Mapping SourceColumn="CarTypeID" DataSetColumn="CarTypeID" />
              <Mapping SourceColumn="Memo" DataSetColumn="Memo" />
              <Mapping SourceColumn="Setup" DataSetColumn="Setup" />
              <Mapping SourceColumn="Sign" DataSetColumn="Sign" />
              <Mapping SourceColumn="LimitSpeed" DataSetColumn="LimitSpeed" />
              <Mapping SourceColumn="RecordTime" DataSetColumn="RecordTime" />
              <Mapping SourceColumn="RestTime" DataSetColumn="RestTime" />
              <Mapping SourceColumn="SuperTime" DataSetColumn="SuperTime" />
              <Mapping SourceColumn="BuyDate" DataSetColumn="BuyDate" />
              <Mapping SourceColumn="Operator" DataSetColumn="Operator" />
              <Mapping SourceColumn="LastUpdateTime" DataSetColumn="LastUpdateTime" />
              <Mapping SourceColumn="Factor" DataSetColumn="Factor" />
              <Mapping SourceColumn="Sensor" DataSetColumn="Sensor" />
              <Mapping SourceColumn="TiredTime" DataSetColumn="TiredTime" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM VehicleInfo
WHERE (LicensePlate = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="LicensePlate" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength(12)" DbType="String" Direction="Input" ParameterName="LicensePlate" Precision="0" ProviderType="VarWChar" Scale="0" Size="12" SourceColumn="LicensePlate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByBlurLicensePlate" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByBlurLicensePlate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillByBlurLicensePlate">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT VehicleInfo.LicensePlate, VehicleInfo.VIN, VehicleInfo.CarTypeID, 
      VehicleInfo.Factor, CarType.Name, VehicleInfo.Sensor, VehicleInfo.OilPer, 
      VehicleInfo.RIN, VehicleInfo.Brand, VehicleInfo.Model, VehicleInfo.BuyDate, 
      VehicleInfo.CheckMonth, VehicleInfo.[Memo], VehicleInfo.Sign, VehicleInfo.LimitSpeed, 
      VehicleInfo.RecordTime, VehicleInfo.RestTime, VehicleInfo.TiredTime, 
      VehicleInfo.Setup, VehicleInfo.SuperTime, VehicleInfo.Operator, 
      VehicleInfo.LastUpdateTime
FROM (VehicleInfo INNER JOIN
      CarType ON VehicleInfo.CarTypeID = CarType.ID)
WHERE (VehicleInfo.LicensePlate LIKE '%' + ? + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="LicensePlate" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength(12)" DbType="String" Direction="Input" ParameterName="LicensePlate" Precision="0" ProviderType="WChar" Scale="0" Size="12" SourceColumn="LicensePlate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByBlurRIN" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByBlurRIN" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="FillByBlurRIN">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT VehicleInfo.LicensePlate, VehicleInfo.VIN, CarType.Name, VehicleInfo.RIN, 
      VehicleInfo.Brand, VehicleInfo.Model, VehicleInfo.BuyDate, VehicleInfo.CheckMonth, 
      VehicleInfo.Factor, VehicleInfo.Sensor, VehicleInfo.OilPer, VehicleInfo.CarTypeID, 
      VehicleInfo.[Memo], VehicleInfo.Setup, VehicleInfo.Sign, VehicleInfo.LimitSpeed, 
      VehicleInfo.RecordTime, VehicleInfo.RestTime, VehicleInfo.TiredTime, 
      VehicleInfo.SuperTime, VehicleInfo.Operator, VehicleInfo.LastUpdateTime
FROM (VehicleInfo INNER JOIN
      CarType ON VehicleInfo.CarTypeID = CarType.ID)
WHERE (VehicleInfo.RIN LIKE '%' + ? + '%')
ORDER BY VehicleInfo.LastUpdateTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="RIN" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength(20)" DbType="String" Direction="Input" ParameterName="RIN" Precision="0" ProviderType="WChar" Scale="0" Size="20" SourceColumn="RIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByBlurVIN" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByBlurVIN" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="FillByBlurVIN">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT VehicleInfo.LicensePlate, VehicleInfo.VIN, CarType.Name, VehicleInfo.RIN, 
      VehicleInfo.Brand, VehicleInfo.Model, VehicleInfo.BuyDate, VehicleInfo.CheckMonth, 
      VehicleInfo.Factor, VehicleInfo.Sensor, VehicleInfo.OilPer, VehicleInfo.CarTypeID, 
      VehicleInfo.[Memo], VehicleInfo.Setup, VehicleInfo.Sign, VehicleInfo.LimitSpeed, 
      VehicleInfo.RecordTime, VehicleInfo.RestTime, VehicleInfo.TiredTime, 
      VehicleInfo.SuperTime, VehicleInfo.Operator, VehicleInfo.LastUpdateTime
FROM (VehicleInfo INNER JOIN
      CarType ON VehicleInfo.CarTypeID = CarType.ID)
WHERE (VehicleInfo.VIN LIKE '%' + ? + '%')
ORDER BY VehicleInfo.LastUpdateTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="VIN" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength(18)" DbType="String" Direction="Input" ParameterName="VIN" Precision="0" ProviderType="WChar" Scale="0" Size="18" SourceColumn="VIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByCarTypeID" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByCarTypeID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="FillByCarTypeID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT VehicleInfo.LicensePlate, VehicleInfo.VIN, CarType.Name, VehicleInfo.RIN, 
      VehicleInfo.Brand, VehicleInfo.Model, VehicleInfo.BuyDate, VehicleInfo.CheckMonth, 
      VehicleInfo.Factor, VehicleInfo.Sensor, VehicleInfo.OilPer, VehicleInfo.CarTypeID, 
      VehicleInfo.[Memo], VehicleInfo.Setup, VehicleInfo.Sign, VehicleInfo.LimitSpeed, 
      VehicleInfo.RecordTime, VehicleInfo.RestTime, VehicleInfo.TiredTime, 
      VehicleInfo.SuperTime, VehicleInfo.Operator, VehicleInfo.LastUpdateTime
FROM (VehicleInfo INNER JOIN
      CarType ON VehicleInfo.CarTypeID = CarType.ID)
WHERE (VehicleInfo.CarTypeID = ?)
ORDER BY VehicleInfo.LastUpdateTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="CarTypeID" DataSourceName="VehicleInfo" DataTypeServer="DbType.Byte" DbType="Byte" Direction="Input" ParameterName="CarTypeID" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="CarTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByLicensePlate" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy3" GeneratorSourceName="FillByLicensePlate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="FillByLicensePlate">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT VehicleInfo.LicensePlate, VehicleInfo.VIN, VehicleInfo.CarTypeID, 
      VehicleInfo.Factor, CarType.Name, VehicleInfo.Sensor, VehicleInfo.OilPer, 
      VehicleInfo.RIN, VehicleInfo.Brand, VehicleInfo.Model, VehicleInfo.BuyDate, 
      VehicleInfo.CheckMonth, VehicleInfo.[Memo], VehicleInfo.Sign, VehicleInfo.LimitSpeed, 
      VehicleInfo.RecordTime, VehicleInfo.RestTime, VehicleInfo.TiredTime, 
      VehicleInfo.Setup, VehicleInfo.SuperTime, VehicleInfo.Operator, 
      VehicleInfo.LastUpdateTime
FROM (VehicleInfo INNER JOIN
      CarType ON VehicleInfo.CarTypeID = CarType.ID)
WHERE (VehicleInfo.LicensePlate = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="LicensePlate" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength(12)" DbType="String" Direction="Input" ParameterName="LicensePlate" Precision="0" ProviderType="WChar" Scale="0" Size="12" SourceColumn="LicensePlate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByRIN" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy6" GeneratorSourceName="FillByRIN" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy6" UserSourceName="FillByRIN">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT VehicleInfo.LicensePlate, VehicleInfo.VIN, CarType.Name, VehicleInfo.RIN, 
      VehicleInfo.Brand, VehicleInfo.Model, VehicleInfo.BuyDate, VehicleInfo.CheckMonth, 
      VehicleInfo.Factor, VehicleInfo.Sensor, VehicleInfo.OilPer, VehicleInfo.CarTypeID, 
      VehicleInfo.[Memo], VehicleInfo.Setup, VehicleInfo.Sign, VehicleInfo.LimitSpeed, 
      VehicleInfo.RecordTime, VehicleInfo.RestTime, VehicleInfo.TiredTime, 
      VehicleInfo.SuperTime, VehicleInfo.Operator, VehicleInfo.LastUpdateTime
FROM (VehicleInfo INNER JOIN
      CarType ON VehicleInfo.CarTypeID = CarType.ID)
WHERE (VehicleInfo.RIN = ?)
ORDER BY VehicleInfo.LastUpdateTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="RIN" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength(20)" DbType="String" Direction="Input" ParameterName="RIN" Precision="0" ProviderType="WChar" Scale="0" Size="20" SourceColumn="RIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByVIN" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByVIN" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy7" UserSourceName="FillByVIN">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT VehicleInfo.LicensePlate, VehicleInfo.VIN, CarType.Name, VehicleInfo.RIN, 
      VehicleInfo.Brand, VehicleInfo.Model, VehicleInfo.BuyDate, VehicleInfo.CheckMonth, 
      VehicleInfo.Factor, VehicleInfo.Sensor, VehicleInfo.OilPer, VehicleInfo.CarTypeID, 
      VehicleInfo.[Memo], VehicleInfo.Setup, VehicleInfo.Sign, VehicleInfo.LimitSpeed, 
      VehicleInfo.RecordTime, VehicleInfo.RestTime, VehicleInfo.TiredTime, 
      VehicleInfo.SuperTime, VehicleInfo.Operator, VehicleInfo.LastUpdateTime
FROM (VehicleInfo INNER JOIN
      CarType ON VehicleInfo.CarTypeID = CarType.ID)
WHERE (VehicleInfo.VIN = ?)
ORDER BY VehicleInfo.LastUpdateTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="VIN" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength(18)" DbType="String" Direction="Input" ParameterName="VIN" Precision="0" ProviderType="WChar" Scale="0" Size="18" SourceColumn="VIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="VehicleInfo" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetLicensePlates" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetLicensePlates" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetLicensePlates" UserSourceName="GetLicensePlates">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT LicensePlate FROM VehicleInfo ORDER BY LastUpdateTime DESC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="VehicleInfo" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetVINs" GetMethodModifier="Public" GetMethodName="GetVINs" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetVINs" UserSourceName="GetVINs">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT VIN FROM VehicleInfo ORDER BY LastUpdateTime DESC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy8" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO VehicleInfo
      (LicensePlate, VIN, CarTypeID, Factor, Sensor, OilPer, RIN, Brand, Model, BuyDate, 
      CheckMonth, [Memo], Operator, LastUpdateTime)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="LicensePlate" DataSourceName="" DataTypeServer="unknown" DbType="String" Direction="Input" ParameterName="LicensePlate" Precision="0" ProviderType="VarWChar" Scale="0" Size="12" SourceColumn="LicensePlate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="String" Direction="Input" ParameterName="VIN" Precision="0" ProviderType="VarWChar" Scale="0" Size="18" SourceColumn="VIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Byte" Direction="Input" ParameterName="CarTypeID" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="1024" SourceColumn="CarTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param5" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Int32" Direction="Input" ParameterName="Factor" Precision="0" ProviderType="Integer" Scale="0" Size="1024" SourceColumn="Factor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param6" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Byte" Direction="Input" ParameterName="Sensor" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="1024" SourceColumn="Sensor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param7" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="Single" Direction="Input" ParameterName="OilPer" Precision="0" ProviderType="Single" Scale="0" Size="1024" SourceColumn="OilPer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param8" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="String" Direction="Input" ParameterName="RIN" Precision="0" ProviderType="VarWChar" Scale="0" Size="20" SourceColumn="RIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param9" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="String" Direction="Input" ParameterName="Brand" Precision="0" ProviderType="VarWChar" Scale="0" Size="32" SourceColumn="Brand" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param10" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="String" Direction="Input" ParameterName="Model" Precision="0" ProviderType="VarWChar" Scale="0" Size="20" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param11" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="String" Direction="Input" ParameterName="BuyDate" Precision="0" ProviderType="VarWChar" Scale="0" Size="50" SourceColumn="BuyDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param12" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="String" Direction="Input" ParameterName="CheckMonth" Precision="0" ProviderType="VarWChar" Scale="0" Size="4" SourceColumn="CheckMonth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param13" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="String" Direction="Input" ParameterName="Memo" Precision="0" ProviderType="VarWChar" Scale="0" Size="65535" SourceColumn="Memo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param14" ColumnName="" DataSourceName="" DataTypeServer="unknown" DbType="String" Direction="Input" ParameterName="Operator" Precision="0" ProviderType="VarWChar" Scale="0" Size="50" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="LastUpdateTime" DataSourceName="" DataTypeServer="DbType.Date" DbType="DateTime" Direction="Input" ParameterName="LastUpdateTime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastUpdateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy2" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy9" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE VehicleInfo
SET VIN = ?, CarTypeID = ?, Factor = ?, Sensor = ?, OilPer = ?, RIN = ?, Brand = ?, 
      Model = ?, BuyDate = ?, CheckMonth = ?, [Memo] = ?, Sign = ?, LimitSpeed = ?, 
      RecordTime = ?, SuperTime = ?, TiredTime = ?, Setup = ?, RestTime = ?, 
      Operator = ?, LastUpdateTime = ?
WHERE (LicensePlate = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="VIN" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength(18)" DbType="String" Direction="Input" ParameterName="VIN" Precision="0" ProviderType="WChar" Scale="0" Size="18" SourceColumn="VIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param2" ColumnName="CarTypeID" DataSourceName="VehicleInfo" DataTypeServer="DbType.Byte" DbType="Byte" Direction="Input" ParameterName="CarTypeID" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="CarTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param3" ColumnName="Factor" DataSourceName="VehicleInfo" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="Factor" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Factor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param4" ColumnName="Sensor" DataSourceName="VehicleInfo" DataTypeServer="DbType.Byte" DbType="Byte" Direction="Input" ParameterName="Sensor" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Sensor" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="OilPer" DataSourceName="VehicleInfo" DataTypeServer="DbType.Single" DbType="Decimal" Direction="Input" ParameterName="OilPer" Precision="7" ProviderType="Single" Scale="0" Size="0" SourceColumn="OilPer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param6" ColumnName="RIN" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength(20)" DbType="String" Direction="Input" ParameterName="RIN" Precision="0" ProviderType="WChar" Scale="0" Size="20" SourceColumn="RIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param7" ColumnName="Brand" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength(32)" DbType="String" Direction="Input" ParameterName="Brand" Precision="0" ProviderType="WChar" Scale="0" Size="32" SourceColumn="Brand" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param8" ColumnName="Model" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength(20)" DbType="String" Direction="Input" ParameterName="Model" Precision="0" ProviderType="WChar" Scale="0" Size="20" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param9" ColumnName="BuyDate" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="BuyDate" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="BuyDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param10" ColumnName="CheckMonth" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength(4)" DbType="String" Direction="Input" ParameterName="CheckMonth" Precision="0" ProviderType="WChar" Scale="0" Size="4" SourceColumn="CheckMonth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param11" ColumnName="Memo" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength" DbType="String" Direction="Input" ParameterName="Memo" Precision="0" ProviderType="WChar" Scale="0" Size="536870910" SourceColumn="Memo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param12" ColumnName="Sign" DataSourceName="VehicleInfo" DataTypeServer="DbType.Byte" DbType="Byte" Direction="Input" ParameterName="Sign" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="Sign" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param13" ColumnName="LimitSpeed" DataSourceName="VehicleInfo" DataTypeServer="DbType.Byte" DbType="Byte" Direction="Input" ParameterName="LimitSpeed" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="LimitSpeed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param14" ColumnName="RecordTime" DataSourceName="VehicleInfo" DataTypeServer="DbType.Byte" DbType="Byte" Direction="Input" ParameterName="RecordTime" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="RecordTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param15" ColumnName="SuperTime" DataSourceName="VehicleInfo" DataTypeServer="DbType.Int16" DbType="Int16" Direction="Input" ParameterName="SuperTime" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="SuperTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param16" ColumnName="TiredTime" DataSourceName="VehicleInfo" DataTypeServer="DbType.Byte" DbType="Byte" Direction="Input" ParameterName="TiredTime" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="TiredTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param17" ColumnName="Setup" DataSourceName="VehicleInfo" DataTypeServer="DbType.Boolean(2)" DbType="Boolean" Direction="Input" ParameterName="Setup" Precision="0" ProviderType="Boolean" Scale="0" Size="2" SourceColumn="Setup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param18" ColumnName="RestTime" DataSourceName="VehicleInfo" DataTypeServer="DbType.Byte" DbType="Byte" Direction="Input" ParameterName="RestTime" Precision="0" ProviderType="UnsignedTinyInt" Scale="0" Size="0" SourceColumn="RestTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param19" ColumnName="Operator" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="Operator" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param20" ColumnName="LastUpdateTime" DataSourceName="VehicleInfo" DataTypeServer="DbType.Date" DbType="DateTime" Direction="Input" ParameterName="LastUpdateTime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastUpdateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param21" ColumnName="LicensePlate" DataSourceName="VehicleInfo" DataTypeServer="DbType.StringFixedLength(12)" DbType="String" Direction="Input" ParameterName="Original_LicensePlate" Precision="0" ProviderType="WChar" Scale="0" Size="12" SourceColumn="LicensePlate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RecordInfoTableAdapter" GeneratorDataComponentClassName="RecordInfoTableAdapter" Name="RecordInfo" UserDataComponentName="RecordInfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="RecordInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `RecordInfo` WHERE (((? = 1 AND `ID` IS NULL) OR (`ID` = ?)) AND (`RIN` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_RIN" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="RIN" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `RecordInfo` (`RIN`) VALUES (?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="RIN" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="RIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, RIN
FROM RecordInfo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `RecordInfo` SET `RIN` = ? WHERE (((? = 1 AND `ID` IS NULL) OR (`ID` = ?)) AND (`RIN` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="RIN" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="RIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_RIN" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="RIN" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="RIN" DataSetColumn="RIN" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM RecordInfo
WHERE (RIN = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="RIN" DataSourceName="RecordInfo" DataTypeServer="DbType.StringFixedLength(20)" DbType="String" Direction="Input" ParameterName="RIN" Precision="0" ProviderType="WChar" Scale="0" Size="20" SourceColumn="RIN" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="RecordInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByBlurRIN" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByBlurRIN" GeneratorSourceName="FillByBlurRIN" GetMethodModifier="Public" GetMethodName="GetDataByBlurRIN" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByBlurRIN" UserSourceName="FillByBlurRIN">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, RIN
FROM RecordInfo
WHERE (RIN LIKE '%' + ? + '%')</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="RIN" DataSourceName="RecordInfo" DataTypeServer="DbType.StringFixedLength(20)" DbType="String" Direction="Input" ParameterName="RIN" Precision="0" ProviderType="WChar" Scale="0" Size="20" SourceColumn="RIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="RecordInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByRIN" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByRIN" GeneratorSourceName="FillByRIN" GetMethodModifier="Public" GetMethodName="GetDataByRIN" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByRIN" UserSourceName="FillByRIN">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ID, RIN FROM RecordInfo WHERE (RIN = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="RIN" DataSourceName="RecordInfo" DataTypeServer="DbType.StringFixedLength(20)" DbType="String" Direction="Input" ParameterName="RIN" Precision="0" ProviderType="WChar" Scale="0" Size="20" SourceColumn="RIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="DriverInfoTableAdapter" GeneratorDataComponentClassName="DriverInfoTableAdapter" Name="DriverInfo" UserDataComponentName="DriverInfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="DriverInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `DriverInfo` WHERE ((`DIN` = ?) AND ((? = 1 AND `DriverID` IS NULL) OR (`DriverID` = ?)) AND ((? = 1 AND `Name` IS NULL) OR (`Name` = ?)) AND ((? = 1 AND `Sex` IS NULL) OR (`Sex` = ?)) AND ((? = 1 AND `LastUpdateTime` IS NULL) OR (`LastUpdateTime` = ?)) AND ((? = 1 AND `Operator` IS NULL) OR (`Operator` = ?)) AND ((? = 1 AND `HasSet` IS NULL) OR (`HasSet` = ?)) AND ((? = 1 AND `Phone` IS NULL) OR (`Phone` = ?)) AND ((? = 1 AND `Address` IS NULL) OR (`Address` = ?)) AND ((? = 1 AND `StartWorkDate` IS NULL) OR (`StartWorkDate` = ?)) AND ((? = 1 AND `DriveAge` IS NULL) OR (`DriveAge` = ?)) AND ((? = 1 AND `CarType` IS NULL) OR (`CarType` = ?)) AND ((? = 1 AND `LicensePlate` IS NULL) OR (`LicensePlate` = ?)) AND ((? = 1 AND `HoldDate` IS NULL) OR (`HoldDate` = ?)) AND ((? = 1 AND `ValidDate` IS NULL) OR (`ValidDate` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_DIN" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="DIN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DriverID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DriverID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_DriverID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DriverID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Name" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Sex" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Sex" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_LastUpdateTime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="LastUpdateTime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="Original_LastUpdateTime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastUpdateTime" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Operator" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Operator" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Operator" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_HasSet" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="HasSet" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="Original_HasSet" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="HasSet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Phone" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_Address" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_StartWorkDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="StartWorkDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_StartWorkDate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StartWorkDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_DriveAge" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DriveAge" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_DriveAge" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="DriveAge" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_CarType" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="CarType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_CarType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CarType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_LicensePlate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="LicensePlate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_LicensePlate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LicensePlate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_HoldDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="HoldDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_HoldDate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="HoldDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_ValidDate" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ValidDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="Original_ValidDate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ValidDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `DriverInfo` (`DIN`, `DriverID`, `Name`, `Sex`, `LastUpdateTime`, `Operator`, `HasSet`, `Memo`, `Phone`, `Address`, `StartWorkDate`, `DriveAge`, `CarType`, `LicensePlate`, `HoldDate`, `ValidDate`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="DIN" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="DIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="DriverID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DriverID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Sex" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="LastUpdateTime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastUpdateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Operator" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="HasSet" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="HasSet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Memo" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Memo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Phone" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Address" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="StartWorkDate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="StartWorkDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="DriveAge" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="DriveAge" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="CarType" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="CarType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="LicensePlate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="LicensePlate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="HoldDate" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="HoldDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="ValidDate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ValidDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT DIN, DriverID, Name, Sex, LastUpdateTime, Operator, HasSet, [Memo], Phone, 
      Address, StartWorkDate, DriveAge, CarType, LicensePlate, HoldDate, ValidDate
FROM DriverInfo
ORDER BY LastUpdateTime DESC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE DriverInfo
SET DriverID = ?, Name = ?, Sex = ?, LastUpdateTime = ?, Operator = ?, HasSet = ?, 
      [Memo] = ?, Phone = ?, Address = ?, StartWorkDate = ?, DriveAge = ?, CarType = ?, 
      LicensePlate = ?, HoldDate = ?, ValidDate = ?
WHERE (DIN = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param16" ColumnName="DIN" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(20)" DbType="String" Direction="Input" ParameterName="Original_DIN" Precision="0" ProviderType="WChar" Scale="0" Size="20" SourceColumn="DIN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="DriverID" DataSourceName="DriverInfo" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="DriverID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DriverID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="Name" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(15)" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="WChar" Scale="0" Size="15" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="Sex" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(8)" DbType="String" Direction="Input" ParameterName="Sex" Precision="0" ProviderType="WChar" Scale="0" Size="8" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="LastUpdateTime" DataSourceName="DriverInfo" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="LastUpdateTime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastUpdateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="Operator" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="Operator" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param6" ColumnName="HasSet" DataSourceName="DriverInfo" DataTypeServer="DbType.Boolean(2)" DbType="Boolean" Direction="Input" ParameterName="HasSet" Precision="0" ProviderType="Boolean" Scale="0" Size="2" SourceColumn="HasSet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param7" ColumnName="Memo" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength" DbType="String" Direction="Input" ParameterName="Memo" Precision="0" ProviderType="WChar" Scale="0" Size="1024" SourceColumn="Memo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param8" ColumnName="Phone" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(18)" DbType="String" Direction="Input" ParameterName="Phone" Precision="0" ProviderType="WChar" Scale="0" Size="18" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param9" ColumnName="Address" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(30)" DbType="String" Direction="Input" ParameterName="Address" Precision="0" ProviderType="WChar" Scale="0" Size="30" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param10" ColumnName="StartWorkDate" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="StartWorkDate" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="StartWorkDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param11" ColumnName="DriveAge" DataSourceName="DriverInfo" DataTypeServer="DbType.Int16" DbType="Int16" Direction="Input" ParameterName="DriveAge" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="DriveAge" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param12" ColumnName="CarType" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(20)" DbType="String" Direction="Input" ParameterName="CarType" Precision="0" ProviderType="WChar" Scale="0" Size="20" SourceColumn="CarType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param13" ColumnName="LicensePlate" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(15)" DbType="String" Direction="Input" ParameterName="LicensePlate" Precision="0" ProviderType="WChar" Scale="0" Size="15" SourceColumn="LicensePlate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param14" ColumnName="HoldDate" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="HoldDate" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="HoldDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param15" ColumnName="ValidDate" DataSourceName="DriverInfo" DataTypeServer="DbType.Int16" DbType="Int16" Direction="Input" ParameterName="ValidDate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ValidDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="DIN" DataSetColumn="DIN" />
              <Mapping SourceColumn="DriverID" DataSetColumn="DriverID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Sex" DataSetColumn="Sex" />
              <Mapping SourceColumn="LastUpdateTime" DataSetColumn="LastUpdateTime" />
              <Mapping SourceColumn="Operator" DataSetColumn="Operator" />
              <Mapping SourceColumn="HasSet" DataSetColumn="HasSet" />
              <Mapping SourceColumn="Memo" DataSetColumn="Memo" />
              <Mapping SourceColumn="Phone" DataSetColumn="Phone" />
              <Mapping SourceColumn="Address" DataSetColumn="Address" />
              <Mapping SourceColumn="StartWorkDate" DataSetColumn="StartWorkDate" />
              <Mapping SourceColumn="DriveAge" DataSetColumn="DriveAge" />
              <Mapping SourceColumn="CarType" DataSetColumn="CarType" />
              <Mapping SourceColumn="LicensePlate" DataSetColumn="LicensePlate" />
              <Mapping SourceColumn="HoldDate" DataSetColumn="HoldDate" />
              <Mapping SourceColumn="ValidDate" DataSetColumn="ValidDate" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM DriverInfo
WHERE (DIN = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="DIN" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(20)" DbType="String" Direction="Input" ParameterName="DIN" Precision="0" ProviderType="WChar" Scale="0" Size="20" SourceColumn="DIN" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="DriverInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByBlurDIN" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByBlurDIN" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="FillByBlurDIN">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Address, CarType, DIN, DriveAge, DriverID, HasSet, HoldDate, LastUpdateTime, LicensePlate, [Memo], Name, Operator, Phone, Sex, StartWorkDate, ValidDate FROM DriverInfo WHERE (DIN LIKE '%' + ? + '%') ORDER BY LastUpdateTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="DIN" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(20)" DbType="String" Direction="Input" ParameterName="DIN" Precision="0" ProviderType="WChar" Scale="0" Size="20" SourceColumn="DIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="DriverInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByBlurLicensePlate" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByBlurLicensePlate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="FillByBlurLicensePlate">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Address, CarType, DIN, DriveAge, DriverID, HasSet, HoldDate, LastUpdateTime, LicensePlate, [Memo], Name, Operator, Phone, Sex, StartWorkDate, ValidDate FROM DriverInfo WHERE (LicensePlate LIKE '%' + ? + '%') ORDER BY LastUpdateTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="LicensePlate" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(15)" DbType="String" Direction="Input" ParameterName="LicensePlate" Precision="0" ProviderType="WChar" Scale="0" Size="15" SourceColumn="LicensePlate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="DriverInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByBlurName" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByBlurName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="FillByBlurName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Address, CarType, DIN, DriveAge, DriverID, HasSet, HoldDate, LastUpdateTime, LicensePlate, [Memo], Name, Operator, Phone, Sex, StartWorkDate, ValidDate FROM DriverInfo WHERE (Name LIKE '%' + ? + '%') ORDER BY LastUpdateTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Name" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(15)" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="WChar" Scale="0" Size="15" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="DriverInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDIN" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByDIN" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="FillByDIN">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Address, CarType, DIN, DriveAge, DriverID, HasSet, HoldDate, LastUpdateTime, LicensePlate, [Memo], Name, Operator, Phone, Sex, StartWorkDate, ValidDate FROM DriverInfo WHERE (DIN = ?) ORDER BY LastUpdateTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="Param1" ColumnName="DIN" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(20)" DbType="String" Direction="Input" ParameterName="DIN" Precision="0" ProviderType="WChar" Scale="0" Size="20" SourceColumn="DIN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="DriverInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByDriverID" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByDriverID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="FillByDriverID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Address, CarType, DIN, DriveAge, DriverID, HasSet, HoldDate, LastUpdateTime, LicensePlate, [Memo], Name, Operator, Phone, Sex, StartWorkDate, ValidDate FROM DriverInfo WHERE (DriverID = ?) ORDER BY LastUpdateTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="DriverID" DataSourceName="DriverInfo" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="DriverID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DriverID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="DriverInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByLicensePlate" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorSourceName="FillByLicensePlate" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy6" UserSourceName="FillByLicensePlate">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Address, CarType, DIN, DriveAge, DriverID, HasSet, HoldDate, LastUpdateTime, LicensePlate, [Memo], Name, Operator, Phone, Sex, StartWorkDate, ValidDate FROM DriverInfo WHERE (LicensePlate = ?) ORDER BY LastUpdateTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="LicensePlate" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(15)" DbType="String" Direction="Input" ParameterName="LicensePlate" Precision="0" ProviderType="WChar" Scale="0" Size="15" SourceColumn="LicensePlate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="DriverInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByName" GenerateMethods="Fill" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy1" GeneratorSourceName="FillByName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy7" UserSourceName="FillByName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Address, CarType, DIN, DriveAge, DriverID, HasSet, HoldDate, LastUpdateTime, LicensePlate, [Memo], Name, Operator, Phone, Sex, StartWorkDate, ValidDate FROM DriverInfo WHERE (Name = ?) ORDER BY LastUpdateTime DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="Name" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(15)" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="WChar" Scale="0" Size="15" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="DriverInfo" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDINs" GetMethodModifier="Public" GetMethodName="GetDINs" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDINs" UserSourceName="GetDINs">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Address, CarType, DIN, DriveAge, DriverID, HasSet, HoldDate, LastUpdateTime, LicensePlate, [Memo], Name, Operator, Phone, Sex, StartWorkDate, ValidDate FROM DriverInfo ORDER BY LastUpdateTime DESC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="DriverInfo" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetDriverIDs" GetMethodModifier="Public" GetMethodName="GetDriverIDs" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDriverIDs" UserSourceName="GetDriverIDs">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Address, CarType, DIN, DriveAge, DriverID, HasSet, HoldDate, LastUpdateTime, LicensePlate, [Memo], Name, Operator, Phone, Sex, StartWorkDate, ValidDate FROM DriverInfo ORDER BY LastUpdateTime DESC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="SystemDB (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateQuery" Modifier="Public" Name="UpdateQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy8" UserSourceName="UpdateQuery">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE DriverInfo
SET DriverID = ?, Name = ?, Sex = ?, LastUpdateTime = ?, Operator = ?, HasSet = ?, 
      [Memo] = ?, Phone = ?, Address = ?, StartWorkDate = ?, DriveAge = ?, CarType = ?, 
      LicensePlate = ?, HoldDate = ?, ValidDate = ?
WHERE (DIN = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="Param1" ColumnName="DriverID" DataSourceName="DriverInfo" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="DriverID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="DriverID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param2" ColumnName="Name" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(15)" DbType="String" Direction="Input" ParameterName="Name" Precision="0" ProviderType="WChar" Scale="0" Size="15" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param3" ColumnName="Sex" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(8)" DbType="String" Direction="Input" ParameterName="Sex" Precision="0" ProviderType="WChar" Scale="0" Size="8" SourceColumn="Sex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param4" ColumnName="LastUpdateTime" DataSourceName="DriverInfo" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="LastUpdateTime" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="LastUpdateTime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param5" ColumnName="Operator" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="Operator" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="Operator" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param6" ColumnName="HasSet" DataSourceName="DriverInfo" DataTypeServer="DbType.Boolean(2)" DbType="Boolean" Direction="Input" ParameterName="HasSet" Precision="0" ProviderType="Boolean" Scale="0" Size="2" SourceColumn="HasSet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param7" ColumnName="Memo" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength" DbType="String" Direction="Input" ParameterName="Memo" Precision="0" ProviderType="WChar" Scale="0" Size="1024" SourceColumn="Memo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param8" ColumnName="Phone" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(18)" DbType="String" Direction="Input" ParameterName="Phone" Precision="0" ProviderType="WChar" Scale="0" Size="18" SourceColumn="Phone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param9" ColumnName="Address" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(30)" DbType="String" Direction="Input" ParameterName="Address" Precision="0" ProviderType="WChar" Scale="0" Size="30" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param10" ColumnName="StartWorkDate" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="StartWorkDate" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="StartWorkDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param11" ColumnName="DriveAge" DataSourceName="DriverInfo" DataTypeServer="DbType.Int16" DbType="Int16" Direction="Input" ParameterName="DriveAge" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="DriveAge" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param12" ColumnName="CarType" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(20)" DbType="String" Direction="Input" ParameterName="CarType" Precision="0" ProviderType="WChar" Scale="0" Size="20" SourceColumn="CarType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param13" ColumnName="LicensePlate" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(15)" DbType="String" Direction="Input" ParameterName="LicensePlate" Precision="0" ProviderType="WChar" Scale="0" Size="15" SourceColumn="LicensePlate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param14" ColumnName="HoldDate" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="HoldDate" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="HoldDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="Param15" ColumnName="ValidDate" DataSourceName="DriverInfo" DataTypeServer="DbType.Int16" DbType="Int16" Direction="Input" ParameterName="ValidDate" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="ValidDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="Param16" ColumnName="DIN" DataSourceName="DriverInfo" DataTypeServer="DbType.StringFixedLength(20)" DbType="String" Direction="Input" ParameterName="Original_DIN" Precision="0" ProviderType="WChar" Scale="0" Size="20" SourceColumn="DIN" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SystemDBDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="SystemDBDataSet" msprop:Generator_DataSetName="SystemDBDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="CarType" msprop:Generator_UserTableName="CarType" msprop:Generator_RowDeletedName="CarTypeRowDeleted" msprop:Generator_RowChangedName="CarTypeRowChanged" msprop:Generator_RowClassName="CarTypeRow" msprop:Generator_RowChangingName="CarTypeRowChanging" msprop:Generator_RowEvArgName="CarTypeRowChangeEvent" msprop:Generator_RowEvHandlerName="CarTypeRowChangeEventHandler" msprop:Generator_TableClassName="CarTypeDataTable" msprop:Generator_TableVarName="tableCarType" msprop:Generator_RowDeletingName="CarTypeRowDeleting" msprop:Generator_TablePropName="CarType">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:unsignedByte" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="VehicleInfo" msprop:Generator_UserTableName="VehicleInfo" msprop:Generator_RowDeletedName="VehicleInfoRowDeleted" msprop:Generator_RowChangedName="VehicleInfoRowChanged" msprop:Generator_RowClassName="VehicleInfoRow" msprop:Generator_RowChangingName="VehicleInfoRowChanging" msprop:Generator_RowEvArgName="VehicleInfoRowChangeEvent" msprop:Generator_RowEvHandlerName="VehicleInfoRowChangeEventHandler" msprop:Generator_TableClassName="VehicleInfoDataTable" msprop:Generator_TableVarName="tableVehicleInfo" msprop:Generator_RowDeletingName="VehicleInfoRowDeleting" msprop:Generator_TablePropName="VehicleInfo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="LicensePlate" msprop:Generator_UserColumnName="LicensePlate" msprop:Generator_ColumnVarNameInTable="columnLicensePlate" msprop:Generator_ColumnPropNameInRow="LicensePlate" msprop:Generator_ColumnPropNameInTable="LicensePlateColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VIN" msprop:Generator_UserColumnName="VIN" msprop:Generator_ColumnVarNameInTable="columnVIN" msprop:Generator_ColumnPropNameInRow="VIN" msprop:Generator_ColumnPropNameInTable="VINColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="18" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RIN" msprop:Generator_UserColumnName="RIN" msprop:Generator_ColumnVarNameInTable="columnRIN" msprop:Generator_ColumnPropNameInRow="RIN" msprop:Generator_ColumnPropNameInTable="RINColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Brand" msprop:Generator_UserColumnName="Brand" msprop:Generator_ColumnVarNameInTable="columnBrand" msprop:Generator_ColumnPropNameInRow="Brand" msprop:Generator_ColumnPropNameInTable="BrandColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Model" msprop:Generator_UserColumnName="Model" msprop:Generator_ColumnVarNameInTable="columnModel" msprop:Generator_ColumnPropNameInRow="Model" msprop:Generator_ColumnPropNameInTable="ModelColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BuyDate" msprop:Generator_UserColumnName="BuyDate" msprop:Generator_ColumnVarNameInTable="columnBuyDate" msprop:Generator_ColumnPropNameInRow="BuyDate" msprop:Generator_ColumnPropNameInTable="BuyDateColumn" type="xs:string" minOccurs="0" />
              <xs:element name="CheckMonth" msprop:Generator_UserColumnName="CheckMonth" msprop:Generator_ColumnVarNameInTable="columnCheckMonth" msprop:Generator_ColumnPropNameInRow="CheckMonth" msprop:Generator_ColumnPropNameInTable="CheckMonthColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OilPer" msprop:Generator_UserColumnName="OilPer" msprop:Generator_ColumnVarNameInTable="columnOilPer" msprop:Generator_ColumnPropNameInRow="OilPer" msprop:Generator_ColumnPropNameInTable="OilPerColumn" type="xs:float" minOccurs="0" />
              <xs:element name="CarTypeID" msprop:Generator_UserColumnName="CarTypeID" msprop:Generator_ColumnVarNameInTable="columnCarTypeID" msprop:Generator_ColumnPropNameInRow="CarTypeID" msprop:Generator_ColumnPropNameInTable="CarTypeIDColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="Memo" msprop:Generator_UserColumnName="Memo" msprop:Generator_ColumnVarNameInTable="columnMemo" msprop:Generator_ColumnPropNameInRow="Memo" msprop:Generator_ColumnPropNameInTable="MemoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Setup" msprop:Generator_UserColumnName="Setup" msprop:Generator_ColumnVarNameInTable="columnSetup" msprop:Generator_ColumnPropNameInRow="Setup" msprop:Generator_ColumnPropNameInTable="SetupColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Sign" msprop:Generator_UserColumnName="Sign" msprop:Generator_ColumnVarNameInTable="columnSign" msprop:Generator_ColumnPropNameInRow="Sign" msprop:Generator_ColumnPropNameInTable="SignColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="LimitSpeed" msprop:Generator_UserColumnName="LimitSpeed" msprop:Generator_ColumnPropNameInRow="LimitSpeed" msprop:Generator_ColumnVarNameInTable="columnLimitSpeed" msprop:Generator_ColumnPropNameInTable="LimitSpeedColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="RecordTime" msprop:Generator_UserColumnName="RecordTime" msprop:Generator_ColumnPropNameInRow="RecordTime" msprop:Generator_ColumnVarNameInTable="columnRecordTime" msprop:Generator_ColumnPropNameInTable="RecordTimeColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="RestTime" msprop:Generator_UserColumnName="RestTime" msprop:Generator_ColumnPropNameInRow="RestTime" msprop:Generator_ColumnVarNameInTable="columnRestTime" msprop:Generator_ColumnPropNameInTable="RestTimeColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="SuperTime" msprop:Generator_UserColumnName="SuperTime" msprop:Generator_ColumnPropNameInRow="SuperTime" msprop:Generator_ColumnVarNameInTable="columnSuperTime" msprop:Generator_ColumnPropNameInTable="SuperTimeColumn" type="xs:short" minOccurs="0" />
              <xs:element name="Operator" msprop:Generator_UserColumnName="Operator" msprop:Generator_ColumnVarNameInTable="columnOperator" msprop:Generator_ColumnPropNameInRow="Operator" msprop:Generator_ColumnPropNameInTable="OperatorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastUpdateTime" msprop:Generator_UserColumnName="LastUpdateTime" msprop:Generator_ColumnVarNameInTable="columnLastUpdateTime" msprop:Generator_ColumnPropNameInRow="LastUpdateTime" msprop:Generator_ColumnPropNameInTable="LastUpdateTimeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Factor" msprop:Generator_UserColumnName="Factor" msprop:Generator_ColumnVarNameInTable="columnFactor" msprop:Generator_ColumnPropNameInRow="Factor" msprop:Generator_ColumnPropNameInTable="FactorColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Sensor" msprop:Generator_UserColumnName="Sensor" msprop:Generator_ColumnVarNameInTable="columnSensor" msprop:Generator_ColumnPropNameInRow="Sensor" msprop:Generator_ColumnPropNameInTable="SensorColumn" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="TiredTime" msprop:Generator_UserColumnName="TiredTime" msprop:Generator_ColumnVarNameInTable="columnTiredTime" msprop:Generator_ColumnPropNameInRow="TiredTime" msprop:Generator_ColumnPropNameInTable="TiredTimeColumn" type="xs:unsignedByte" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="RecordInfo" msprop:Generator_UserTableName="RecordInfo" msprop:Generator_RowDeletedName="RecordInfoRowDeleted" msprop:Generator_RowChangedName="RecordInfoRowChanged" msprop:Generator_RowClassName="RecordInfoRow" msprop:Generator_RowChangingName="RecordInfoRowChanging" msprop:Generator_RowEvArgName="RecordInfoRowChangeEvent" msprop:Generator_RowEvHandlerName="RecordInfoRowChangeEventHandler" msprop:Generator_TableClassName="RecordInfoDataTable" msprop:Generator_TableVarName="tableRecordInfo" msprop:Generator_RowDeletingName="RecordInfoRowDeleting" msprop:Generator_TablePropName="RecordInfo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="RIN" msprop:Generator_UserColumnName="RIN" msprop:Generator_ColumnPropNameInRow="RIN" msprop:Generator_ColumnVarNameInTable="columnRIN" msprop:Generator_ColumnPropNameInTable="RINColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DriverInfo" msprop:Generator_UserTableName="DriverInfo" msprop:Generator_RowDeletedName="DriverInfoRowDeleted" msprop:Generator_RowChangedName="DriverInfoRowChanged" msprop:Generator_RowClassName="DriverInfoRow" msprop:Generator_RowChangingName="DriverInfoRowChanging" msprop:Generator_RowEvArgName="DriverInfoRowChangeEvent" msprop:Generator_RowEvHandlerName="DriverInfoRowChangeEventHandler" msprop:Generator_TableClassName="DriverInfoDataTable" msprop:Generator_TableVarName="tableDriverInfo" msprop:Generator_RowDeletingName="DriverInfoRowDeleting" msprop:Generator_TablePropName="DriverInfo">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DIN" msprop:Generator_UserColumnName="DIN" msprop:Generator_ColumnVarNameInTable="columnDIN" msprop:Generator_ColumnPropNameInRow="DIN" msprop:Generator_ColumnPropNameInTable="DINColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DriverID" msprop:Generator_UserColumnName="DriverID" msprop:Generator_ColumnVarNameInTable="columnDriverID" msprop:Generator_ColumnPropNameInRow="DriverID" msprop:Generator_ColumnPropNameInTable="DriverIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sex" msprop:Generator_UserColumnName="Sex" msprop:Generator_ColumnVarNameInTable="columnSex" msprop:Generator_ColumnPropNameInRow="Sex" msprop:Generator_ColumnPropNameInTable="SexColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="8" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastUpdateTime" msprop:Generator_UserColumnName="LastUpdateTime" msprop:Generator_ColumnVarNameInTable="columnLastUpdateTime" msprop:Generator_ColumnPropNameInRow="LastUpdateTime" msprop:Generator_ColumnPropNameInTable="LastUpdateTimeColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Operator" msprop:Generator_UserColumnName="Operator" msprop:Generator_ColumnVarNameInTable="columnOperator" msprop:Generator_ColumnPropNameInRow="Operator" msprop:Generator_ColumnPropNameInTable="OperatorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HasSet" msprop:Generator_UserColumnName="HasSet" msprop:Generator_ColumnVarNameInTable="columnHasSet" msprop:Generator_ColumnPropNameInRow="HasSet" msprop:Generator_ColumnPropNameInTable="HasSetColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Memo" msprop:Generator_UserColumnName="Memo" msprop:Generator_ColumnVarNameInTable="columnMemo" msprop:Generator_ColumnPropNameInRow="Memo" msprop:Generator_ColumnPropNameInTable="MemoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Phone" msprop:Generator_UserColumnName="Phone" msprop:Generator_ColumnVarNameInTable="columnPhone" msprop:Generator_ColumnPropNameInRow="Phone" msprop:Generator_ColumnPropNameInTable="PhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="18" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address" msprop:Generator_UserColumnName="Address" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StartWorkDate" msprop:Generator_UserColumnName="StartWorkDate" msprop:Generator_ColumnVarNameInTable="columnStartWorkDate" msprop:Generator_ColumnPropNameInRow="StartWorkDate" msprop:Generator_ColumnPropNameInTable="StartWorkDateColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DriveAge" msprop:Generator_UserColumnName="DriveAge" msprop:Generator_ColumnVarNameInTable="columnDriveAge" msprop:Generator_ColumnPropNameInRow="DriveAge" msprop:Generator_ColumnPropNameInTable="DriveAgeColumn" type="xs:short" minOccurs="0" />
              <xs:element name="CarType" msprop:Generator_UserColumnName="CarType" msprop:Generator_ColumnVarNameInTable="columnCarType" msprop:Generator_ColumnPropNameInRow="CarType" msprop:Generator_ColumnPropNameInTable="CarTypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LicensePlate" msprop:Generator_UserColumnName="LicensePlate" msprop:Generator_ColumnVarNameInTable="columnLicensePlate" msprop:Generator_ColumnPropNameInRow="LicensePlate" msprop:Generator_ColumnPropNameInTable="LicensePlateColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="15" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HoldDate" msprop:Generator_UserColumnName="HoldDate" msprop:Generator_ColumnVarNameInTable="columnHoldDate" msprop:Generator_ColumnPropNameInRow="HoldDate" msprop:Generator_ColumnPropNameInTable="HoldDateColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValidDate" msprop:Generator_UserColumnName="ValidDate" msprop:Generator_ColumnVarNameInTable="columnValidDate" msprop:Generator_ColumnPropNameInRow="ValidDate" msprop:Generator_ColumnPropNameInTable="ValidDateColumn" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CarType" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="RecordInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:RecordInfo" />
      <xs:field xpath="mstns:RIN" />
    </xs:unique>
    <xs:unique name="DriverInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DriverInfo" />
      <xs:field xpath="mstns:DIN" />
    </xs:unique>
  </xs:element>
</xs:schema>